If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book.

If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.

Thanks to its reliability, robustness, and high performance, PostgreSQL has become the most advanced open source database on the market. This third edition of Mastering PostgreSQL helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both physical and technical aspects of system architecture with ease.Starting with an introduction to the newly released features in PostgreSQL 12, this book will help you build efficient and fault-tolerant PostgreSQL applications. You’ll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management. You’ll also work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and understand how to move from Oracle to PostgreSQL. As you progress through the chapters, you’ll cover transactions, locking, indexes, and how to optimize queries for improved performance. Additionally, you’ll learn how to manage network security and explore backups and replications while understanding useful PostgreSQL extensions to help you in optimizing the performance of large databases.By the end of this PostgreSQL book, you’ll be able to get the most out of your database by implementing advanced administrative tasks effortlessly.

including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you’ll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases. By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

本书从操作系统到数据库实现的多个层面，讲解了PostgreSQL数据库进行常规性能调优的各个场景。无论对于从其他数据库转战PostgreSQL的DBA还是使用过PostgreSQL一段时间的DBA，它都是一本不可多得的参考资料。

A comprehensive series of dependable recipes to design, build, and implement a PostgreSQL server architecture free of common pitfalls that can operate for years to come. Each chapter is packed with instructions and examples to simplify even highly complex database operations. If you are a PostgreSQL DBA working on Linux systems who want a database that never gives up, this book is for you. If you've ever experienced a database outage, restored from a backup, spent hours trying to repair a malfunctioning cluster, or simply want to guarantee system stability, this book is definitely for you.

This book is for Java developers and architects who need to have a deep understanding of how to create or integrate your applications with the Drools Rules Framework. The book assumes that you know the Java language well and also have experience with some widely used frameworks, such as Spring. You should also know the basics of Maven-based applications.

This book is a step-by-step tutorial including all the needed assets to build the three sample projects it covers. It is divided into lots of small sub-topics and follows a clear and logical outline to help you structure your new knowledge. Every single feature covered is immediately illustrated by a meaningful exercise. Self-exploration of the software is strongly encouraged through extra exercises and experimentations. The book also introduces you to the Captivate community by providing lots of external reference and tips and tricks from established e-learning professionals. If you are: A teacher wanting to produce high quality e-learning content for your students. Working in a training department and want to implement e-learning in your company. Using a SCORM or AICC-compliant LMS and want to produce e-learning content to track your students’ performance. A webmaster in need of a fun and interactive way to produce an FAQ or a support site. Interested in e-learning. Then, this book is for you! A basic knowledge of your operating system (Mac or Windows) is all it takes to author the next generation of e-learning content with this book.

This book is a step-by-step tutorial including all the needed assets to build the three sample projects it covers. It is divided into lots of small sub-topics and follows a clear and logical outline to help you structure your new knowledge. Every single feature covered is immediately illustrated by a meaningful exercise. Self-exploration of the software is strongly encouraged through extra exercises and experimentations. The book also introduces you to the Captivate community by providing lots of external reference and tips and tricks from established e-learning professionals. If you are: A teacher wanting to produce high quality e-learning content for your students. Working in a training department and want to implement e-learning in your company. Using a SCORM or AICC-compliant LMS and want to produce e-learning content to track your students’ performance. A webmaster in need of a fun and interactive way to produce an FAQ or a support site. Interested in e-learning. Then, this book is for you! A basic knowledge of your operating system (Mac or Windows) is all it takes to author the next generation of e-learning content with this book.

This book is for Java developers and architects who need to have a deep understanding of how to create or integrate your applications with the Drools Rules Framework. The book assumes that you know the Java language well and also have experience with some widely used frameworks, such as Spring. You should also know the basics of Maven-based applications.